package com.mmd.manage.dao;

import com.mmd.common.entity.MmdQuotation;
import com.mmd.common.mapper.MmdQuotationMapper;
import com.mmd.manage.vo.RouteHscodeVo;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

public interface MmdQuotationDao extends MmdQuotationMapper {
    List<RouteHscodeVo> selectAllHsCode(@Param("quotationNo") String quotationNo);

    MmdQuotation selectQuotationByRouteNo(@Param("routeNo") String routeNo);

    int getQuotationNumberByTimeBetween(@Param("quotationNo")String quotationNo, @Param("routeNo")String routeNo, @Param("validStartTime")Date validStartTime,@Param("validEndTime") Date validEndTime);
//    int getQuotationNumberByTimeBetween(@Param("quotationNo")String quotationNo, @Param("areaId")Long areaId, @Param("channelNo")String channelNo, @Param("validStartTime")Date validStartTime,@Param("validEndTime") Date validEndTime);

    List<MmdQuotation> getQuotationByRoutNo(@Param("routeNo")String routeNo);

    List<MmdQuotation> getQuotationByParams(@Param("routeNo")String routeNo, @Param("channelNo")String channelNo, @Param("areaId")Long areaId, @Param("level") String level);

    void updateValidTime(@Param("quotationNo") String quotationNo, @Param("validStartTime")Date validStartTime, @Param("validEndTime")Date validEndTime);

    List<MmdQuotation> getQuotationGroupByRouteNo(MmdQuotation mmdQuotation);

}
